create table qrtz_triggers
(
    sched_name     nvarchar(120) not null,
    trigger_name   nvarchar(200) not null,
    trigger_group  nvarchar(200) not null,
    job_name       nvarchar(200) not null,
    job_group      nvarchar(200) not null,
    description    nvarchar(250),
    next_fire_time bigint,
    prev_fire_time bigint,
    priority       int,
    trigger_state  nvarchar(16)  not null,
    trigger_type   nvarchar(8)   not null,
    start_time     bigint        not null,
    end_time       bigint,
    calendar_name  nvarchar(200),
    misfire_instr  smallint,
    job_data       varbinary(max),
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_triggers_ibfk_1
        foreign key (sched_name, job_name, job_group) references qrtz_job_details
)
go

exec sp_addextendedproperty 'MS_Description', '触发器详细信息表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN', 'sched_name'
go

exec sp_addextendedproperty 'MS_Description', '触发器的名字', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'trigger_name'
go

exec sp_addextendedproperty 'MS_Description', '触发器所属组的名字', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'trigger_group'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_job_details表job_name的外键', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers',
     'COLUMN', 'job_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_job_details表job_group的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_triggers', 'COLUMN', 'job_group'
go

exec sp_addextendedproperty 'MS_Description', '相关介绍', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN', 'description'
go

exec sp_addextendedproperty 'MS_Description', '上一次触发时间（毫秒）', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'next_fire_time'
go

exec sp_addextendedproperty 'MS_Description', '下一次触发时间（默认为-1表示不触发）', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers',
     'COLUMN', 'prev_fire_time'
go

exec sp_addextendedproperty 'MS_Description', '优先级', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN', 'priority'
go

exec sp_addextendedproperty 'MS_Description', '触发器状态', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'trigger_state'
go

exec sp_addextendedproperty 'MS_Description', '触发器的类型', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'trigger_type'
go

exec sp_addextendedproperty 'MS_Description', '开始时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN', 'start_time'
go

exec sp_addextendedproperty 'MS_Description', '结束时间', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN', 'end_time'
go

exec sp_addextendedproperty 'MS_Description', '日程表名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'calendar_name'
go

exec sp_addextendedproperty 'MS_Description', '补偿执行的策略', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'misfire_instr'
go

exec sp_addextendedproperty 'MS_Description', '存放持久化job对象', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_triggers', 'COLUMN',
     'job_data'
go

INSERT INTO [ry-vue].dbo.qrtz_triggers (sched_name, trigger_name, trigger_group, job_name, job_group, description, next_fire_time, prev_fire_time, priority, trigger_state, trigger_type, start_time, end_time, calendar_name, misfire_instr, job_data) VALUES (N'RuoyiScheduler', N'TASK_CLASS_NAME1', N'DEFAULT', N'TASK_CLASS_NAME1', N'DEFAULT', null, 1646044820000, -1, 5, N'PAUSED', N'CRON', 1646044816000, 0, null, 2, 0x);
INSERT INTO [ry-vue].dbo.qrtz_triggers (sched_name, trigger_name, trigger_group, job_name, job_group, description, next_fire_time, prev_fire_time, priority, trigger_state, trigger_type, start_time, end_time, calendar_name, misfire_instr, job_data) VALUES (N'RuoyiScheduler', N'TASK_CLASS_NAME2', N'DEFAULT', N'TASK_CLASS_NAME2', N'DEFAULT', null, 1646044830000, -1, 5, N'PAUSED', N'CRON', 1646044817000, 0, null, 2, 0x);
INSERT INTO [ry-vue].dbo.qrtz_triggers (sched_name, trigger_name, trigger_group, job_name, job_group, description, next_fire_time, prev_fire_time, priority, trigger_state, trigger_type, start_time, end_time, calendar_name, misfire_instr, job_data) VALUES (N'RuoyiScheduler', N'TASK_CLASS_NAME3', N'DEFAULT', N'TASK_CLASS_NAME3', N'DEFAULT', null, 1646044820000, -1, 5, N'PAUSED', N'CRON', 1646044817000, 0, null, 2, 0x);